SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_GetJYJZ]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	/* SET NOCOUNT ON */
	SELECT TOP(5) JOL_BulletinLecture_No,JOL_BulletinLecture_Title,JOL_BulletinLecture_Time FROM dbo.JOL_BulletinEmploymentLecture
	ORDER BY JOL_BulletinLecture_IsSetTop DESC,JOL_BulletinLecture_Time DESC
	RETURN

GO
